<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="TrackingDataSet" targetNamespace="http://tempuri.org/TrackingDataSet.xsd" xmlns:mstns="http://tempuri.org/TrackingDataSet.xsd" xmlns="http://tempuri.org/TrackingDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ApprovalsConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ApprovalsConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ApprovalsConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserActivityWorkItemTracking2TableAdapter" GeneratorDataComponentClassName="UserActivityWorkItemTracking2TableAdapter" Name="UserActivityWorkItemTracking2" UserDataComponentName="UserActivityWorkItemTracking2TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="ASPNETDB.dbo.UserActivityWorkItemTracking" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[UserActivityWorkItemTracking] WHERE (([ActivityGuid] = @Original_ActivityGuid) AND ([TrackedAt] = @Original_TrackedAt))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TrackedAt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TrackedAt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[UserActivityWorkItemTracking] ([ActivityGuid], [TrackedAt], [ActivityName], [AssignedUser], [WorkflowGuid], [ActivityDescription], [ActivityTypeName], [RequiredRole], [Status], [WorkItemName], [WorkItemType], [Description], [Reason], [DateRequested], [FundingCostCenter], [AreaAffected], [Approved], [Result]) VALUES (@ActivityGuid, @TrackedAt, @ActivityName, @AssignedUser, @WorkflowGuid, @ActivityDescription, @ActivityTypeName, @RequiredRole, @Status, @WorkItemName, @WorkItemType, @Description, @Reason, @DateRequested, @FundingCostCenter, @AreaAffected, @Approved, @Result);
SELECT ActivityGuid, TrackedAt, ActivityName, AssignedUser, WorkflowGuid, ActivityDescription, ActivityTypeName, RequiredRole, Status, WorkItemName, WorkItemType, Description, Reason, DateRequested, FundingCostCenter, AreaAffected, Approved, Result FROM UserActivityWorkItemTracking WHERE (ActivityGuid = @ActivityGuid) AND (TrackedAt = @TrackedAt)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TrackedAt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TrackedAt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@AssignedUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AssignedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WorkflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RequiredRole" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RequiredRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkItemName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkItemType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Reason" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Reason" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateRequested" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateRequested" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FundingCostCenter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FundingCostCenter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AreaAffected" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AreaAffected" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Approved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Approved" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Result" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Result" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM dbo.UserActivityWorkItemTracking</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[UserActivityWorkItemTracking] SET [ActivityGuid] = @ActivityGuid, [TrackedAt] = @TrackedAt, [ActivityName] = @ActivityName, [AssignedUser] = @AssignedUser, [WorkflowGuid] = @WorkflowGuid, [ActivityDescription] = @ActivityDescription, [ActivityTypeName] = @ActivityTypeName, [RequiredRole] = @RequiredRole, [Status] = @Status, [WorkItemName] = @WorkItemName, [WorkItemType] = @WorkItemType, [Description] = @Description, [Reason] = @Reason, [DateRequested] = @DateRequested, [FundingCostCenter] = @FundingCostCenter, [AreaAffected] = @AreaAffected, [Approved] = @Approved, [Result] = @Result WHERE (([ActivityGuid] = @Original_ActivityGuid) AND ([TrackedAt] = @Original_TrackedAt));
SELECT ActivityGuid, TrackedAt, ActivityName, AssignedUser, WorkflowGuid, ActivityDescription, ActivityTypeName, RequiredRole, Status, WorkItemName, WorkItemType, Description, Reason, DateRequested, FundingCostCenter, AreaAffected, Approved, Result FROM UserActivityWorkItemTracking WHERE (ActivityGuid = @ActivityGuid) AND (TrackedAt = @TrackedAt)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TrackedAt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TrackedAt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@AssignedUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AssignedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WorkflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RequiredRole" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RequiredRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkItemName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkItemType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Reason" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Reason" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateRequested" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateRequested" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FundingCostCenter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FundingCostCenter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AreaAffected" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AreaAffected" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Approved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Approved" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Result" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Result" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TrackedAt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TrackedAt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ActivityGuid" DataSetColumn="ActivityGuid" />
              <Mapping SourceColumn="TrackedAt" DataSetColumn="TrackedAt" />
              <Mapping SourceColumn="AssignedUser" DataSetColumn="AssignedUser" />
              <Mapping SourceColumn="WorkflowGuid" DataSetColumn="WorkflowGuid" />
              <Mapping SourceColumn="ActivityDescription" DataSetColumn="ActivityDescription" />
              <Mapping SourceColumn="ActivityTypeName" DataSetColumn="ActivityTypeName" />
              <Mapping SourceColumn="RequiredRole" DataSetColumn="RequiredRole" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="WorkItemName" DataSetColumn="WorkItemName" />
              <Mapping SourceColumn="WorkItemType" DataSetColumn="WorkItemType" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Reason" DataSetColumn="Reason" />
              <Mapping SourceColumn="DateRequested" DataSetColumn="DateRequested" />
              <Mapping SourceColumn="FundingCostCenter" DataSetColumn="FundingCostCenter" />
              <Mapping SourceColumn="AreaAffected" DataSetColumn="AreaAffected" />
              <Mapping SourceColumn="Approved" DataSetColumn="Approved" />
              <Mapping SourceColumn="Result" DataSetColumn="Result" />
              <Mapping SourceColumn="ActivityName" DataSetColumn="ActivityName" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="AddTrackingRecord" Modifier="Public" Name="AddTrackingRecord" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="AddTrackingRecord">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO UserActivityWorkItemTracking
SELECT TOP 1
@activityGuid as ActivityGuid,
GETDATE() as TrackedAt,
@activityName as ActivityName,
UserActivityAssignments.AssignedUser,
@workflowGuid as WorkflowGuid,
@activityDescription as ActivityDescription,
@activityTypeName as ActivityTypeName,
aspnet_Roles.RoleId as RequiredRole,
@status as Status,
@workItemName as WorkItemName,
@workItemType as WorkItemType,
@description as Description,
@reason as Reason,
@dateRequested as DateRequested,
@fundingCostCenter as FundingCostCenter,
@areaAffected as AreaAffected,
@approved as Approved,
@result as Result
FROM aspnet_Roles
LEFT JOIN UserActivityAssignments ON (UserActivityAssignments.ActivityGuid = @activityGuid)
WHERE aspnet_Roles.RoleName = @requiredRole
ORDER BY UserActivityAssignments.DateAssigned DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@activityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@activityName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@workflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@activityDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@activityTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@requiredRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@workItemName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@workItemType" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@reason" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateRequested" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fundingCostCenter" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@areaAffected" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@approved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@result" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CountActivityRecordWithStatus" Modifier="Public" Name="CountActivityRecordWithStatus" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="CountActivityRecordWithStatus">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*)
FROM            UserActivityWorkItemTracking
WHERE        (ActivityGuid = @activityGuid) AND (Status = @status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="activityGuid" ColumnName="ActivityGuid" DataSourceName="ASPNETDB.dbo.UserActivityWorkItemTracking" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@activityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="status" ColumnName="Status" DataSourceName="ASPNETDB.dbo.UserActivityWorkItemTracking" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="ASPNETDB.dbo.UserActivityWorkItemTracking" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetLatestFor" GetMethodModifier="Public" GetMethodName="GetLatestFor" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetLatestFor" UserSourceName="GetLatestFor">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TOP (1) ActivityDescription, ActivityGuid, ActivityName, ActivityTypeName, Approved, AreaAffected, AssignedUser, DateRequested, Description, FundingCostCenter, Reason, RequiredRole, Result, Status, TrackedAt, WorkItemName, WorkItemType, WorkflowGuid FROM UserActivityWorkItemTracking WHERE (WorkflowGuid = @workflowGuid) ORDER BY TrackedAt DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="workflowGuid" ColumnName="WorkflowGuid" DataSourceName="ASPNETDB.dbo.UserActivityWorkItemTracking" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@workflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkflowTrackingTableAdapter" GeneratorDataComponentClassName="WorkflowTrackingTableAdapter" Name="WorkflowTracking" UserDataComponentName="WorkflowTrackingTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="ASPNETDB.dbo.WorkflowTracking" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[WorkflowTracking] WHERE (([WorkflowGuid] = @Original_WorkflowGuid) AND ([Started] = @Original_Started) AND ((@IsNull_Finished = 1 AND [Finished] IS NULL) OR ([Finished] = @Original_Finished)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_WorkflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Started" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Started" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Finished" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Finished" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Finished" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Finished" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[WorkflowTracking] ([WorkflowGuid], [Started], [Finished]) VALUES (@WorkflowGuid, @Started, @Finished);
SELECT WorkflowGuid, Started, Finished FROM WorkflowTracking WHERE (WorkflowGuid = @WorkflowGuid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WorkflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Started" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Started" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Finished" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Finished" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT WorkflowGuid, Started, Finished FROM dbo.WorkflowTracking</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[WorkflowTracking] SET [WorkflowGuid] = @WorkflowGuid, [Started] = @Started, [Finished] = @Finished WHERE (([WorkflowGuid] = @Original_WorkflowGuid) AND ([Started] = @Original_Started) AND ((@IsNull_Finished = 1 AND [Finished] IS NULL) OR ([Finished] = @Original_Finished)));
SELECT WorkflowGuid, Started, Finished FROM WorkflowTracking WHERE (WorkflowGuid = @WorkflowGuid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WorkflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Started" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Started" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Finished" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Finished" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_WorkflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Started" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Started" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Finished" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Finished" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Finished" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Finished" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WorkflowGuid" DataSetColumn="WorkflowGuid" />
              <Mapping SourceColumn="Started" DataSetColumn="Started" />
              <Mapping SourceColumn="Finished" DataSetColumn="Finished" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="Finish" Modifier="Public" Name="Finish" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="Finish">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [dbo].[WorkflowTracking] 
SET [Finished] = @finished 
WHERE [WorkflowGuid] = @workflowGuid;
SELECT WorkflowGuid, Started, Finished FROM WorkflowTracking WHERE (WorkflowGuid = @workflowGuid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="finished" ColumnName="Finished" DataSourceName="ASPNETDB.dbo.WorkflowTracking" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@finished" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="Finished" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="workflowGuid" ColumnName="WorkflowGuid" DataSourceName="ASPNETDB.dbo.WorkflowTracking" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@workflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkflowInformationTableAdapter" GeneratorDataComponentClassName="WorkflowInformationTableAdapter" Name="WorkflowInformation" UserDataComponentName="WorkflowInformationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="ASPNETDB.dbo.WorkflowInformation" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM dbo.WorkflowInformation</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WorkflowGuid" DataSetColumn="WorkflowGuid" />
              <Mapping SourceColumn="Started" DataSetColumn="Started" />
              <Mapping SourceColumn="WaitingOn" DataSetColumn="WaitingOn" />
              <Mapping SourceColumn="Finished" DataSetColumn="Finished" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="ASPNETDB.dbo.WorkflowInformation" DbObjectType="View" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetFinished" GetMethodModifier="Public" GetMethodName="GetFinished" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetFinished" UserSourceName="GetFinished">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Name, WorkflowGuid, Started, WaitingOn, Finished
FROM            WorkflowInformation
WHERE        (Finished IS NOT NULL)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="ASPNETDB.dbo.WorkflowInformation" DbObjectType="View" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetRunning" GetMethodModifier="Public" GetMethodName="GetRunning" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetRunning" UserSourceName="GetRunning">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Name, WorkflowGuid, Started, WaitingOn, Finished
FROM            WorkflowInformation
WHERE        (Finished IS NULL)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserActivityWorkItemTrackingTableAdapter" GeneratorDataComponentClassName="UserActivityWorkItemTrackingTableAdapter" Name="UserActivityWorkItemTracking" UserDataComponentName="UserActivityWorkItemTrackingTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="SMS.dbo.UserActivityWorkItemTracking" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [UserActivityWorkItemTracking] WHERE (([ActivityGuid] = @Original_ActivityGuid) AND ([TrackedAt] = @Original_TrackedAt))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TrackedAt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TrackedAt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [UserActivityWorkItemTracking] ([ActivityGuid], [TrackedAt], [ActivityName], [AssignedUser], [WorkflowGuid], [ActivityDescription], [ActivityTypeName], [RequiredRole], [Status], [WorkItemName], [WorkItemType], [Description], [IsAnonymous], [DateReport], [Advice], [otherAdvice], [Approved], [ReporterID]) VALUES (@ActivityGuid, @TrackedAt, @ActivityName, @AssignedUser, @WorkflowGuid, @ActivityDescription, @ActivityTypeName, @RequiredRole, @Status, @WorkItemName, @WorkItemType, @Description, @IsAnonymous, @DateReport, @Advice, @otherAdvice, @Approved, @ReporterID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TrackedAt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TrackedAt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@AssignedUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AssignedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WorkflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RequiredRole" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RequiredRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkItemName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkItemType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsAnonymous" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsAnonymous" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateReport" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateReport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Advice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Advice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@otherAdvice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="otherAdvice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Approved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Approved" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ReporterID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReporterID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   UserActivityWorkItemTracking.*
FROM      UserActivityWorkItemTracking</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [UserActivityWorkItemTracking] SET [ActivityGuid] = @ActivityGuid, [TrackedAt] = @TrackedAt, [ActivityName] = @ActivityName, [AssignedUser] = @AssignedUser, [WorkflowGuid] = @WorkflowGuid, [ActivityDescription] = @ActivityDescription, [ActivityTypeName] = @ActivityTypeName, [RequiredRole] = @RequiredRole, [Status] = @Status, [WorkItemName] = @WorkItemName, [WorkItemType] = @WorkItemType, [Description] = @Description, [IsAnonymous] = @IsAnonymous, [DateReport] = @DateReport, [Advice] = @Advice, [otherAdvice] = @otherAdvice, [Approved] = @Approved, [ReporterID] = @ReporterID WHERE (([ActivityGuid] = @Original_ActivityGuid) AND ([TrackedAt] = @Original_TrackedAt))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TrackedAt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TrackedAt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@AssignedUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AssignedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WorkflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RequiredRole" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RequiredRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkItemName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkItemType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsAnonymous" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsAnonymous" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateReport" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateReport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Advice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Advice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@otherAdvice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="otherAdvice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Approved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Approved" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ReporterID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReporterID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TrackedAt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TrackedAt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ActivityGuid" DataSetColumn="ActivityGuid" />
              <Mapping SourceColumn="TrackedAt" DataSetColumn="TrackedAt" />
              <Mapping SourceColumn="ActivityName" DataSetColumn="ActivityName" />
              <Mapping SourceColumn="AssignedUser" DataSetColumn="AssignedUser" />
              <Mapping SourceColumn="WorkflowGuid" DataSetColumn="WorkflowGuid" />
              <Mapping SourceColumn="ActivityDescription" DataSetColumn="ActivityDescription" />
              <Mapping SourceColumn="ActivityTypeName" DataSetColumn="ActivityTypeName" />
              <Mapping SourceColumn="RequiredRole" DataSetColumn="RequiredRole" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="WorkItemName" DataSetColumn="WorkItemName" />
              <Mapping SourceColumn="WorkItemType" DataSetColumn="WorkItemType" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="IsAnonymous" DataSetColumn="IsAnonymous" />
              <Mapping SourceColumn="DateReport" DataSetColumn="DateReport" />
              <Mapping SourceColumn="Advice" DataSetColumn="Advice" />
              <Mapping SourceColumn="otherAdvice" DataSetColumn="otherAdvice" />
              <Mapping SourceColumn="Approved" DataSetColumn="Approved" />
              <Mapping SourceColumn="ReporterID" DataSetColumn="ReporterID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="AddTrackingRecord" Modifier="Public" Name="AddTrackingRecord" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="AddTrackingRecord">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [UserActivityWorkItemTracking] ([ActivityGuid], [TrackedAt], [ActivityName], [AssignedUser], [WorkflowGuid], [ActivityDescription], [ActivityTypeName], [RequiredRole], [Status], [WorkItemName], [WorkItemType], [Description], [IsAnonymous], [DateReport], [Advice], [otherAdvice], [Approved], [ReporterID]) VALUES (@ActivityGuid, @TrackedAt, @ActivityName, @AssignedUser, @WorkflowGuid, @ActivityDescription, @ActivityTypeName, @RequiredRole, @Status, @WorkItemName, @WorkItemType, @Description, @IsAnonymous, @DateReport, @Advice, @otherAdvice, @Approved, @ReporterID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ActivityGuid" ColumnName="ActivityGuid" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TrackedAt" ColumnName="TrackedAt" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@TrackedAt" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="TrackedAt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ActivityName" ColumnName="ActivityName" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@ActivityName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="ActivityName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="AssignedUser" ColumnName="AssignedUser" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@AssignedUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="AssignedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="WorkflowGuid" ColumnName="WorkflowGuid" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@WorkflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ActivityDescription" ColumnName="ActivityDescription" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nvarchar(256)" DbType="String" Direction="Input" ParameterName="@ActivityDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumn="ActivityDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ActivityTypeName" ColumnName="ActivityTypeName" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@ActivityTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="ActivityTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="RequiredRole" ColumnName="RequiredRole" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@RequiredRole" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequiredRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Status" ColumnName="Status" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="WorkItemName" ColumnName="WorkItemName" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nvarchar(256)" DbType="String" Direction="Input" ParameterName="@WorkItemName" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumn="WorkItemName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="WorkItemType" ColumnName="WorkItemType" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@WorkItemType" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="WorkItemType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Description" ColumnName="Description" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsAnonymous" ColumnName="IsAnonymous" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAnonymous" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAnonymous" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DateReport" ColumnName="DateReport" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DateReport" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="DateReport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Advice" ColumnName="Advice" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Advice" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Advice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="otherAdvice" ColumnName="otherAdvice" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@otherAdvice" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="otherAdvice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Approved" ColumnName="Approved" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Approved" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Approved" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ReporterID" ColumnName="ReporterID" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@ReporterID" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="ReporterID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO UserActivityWorkItemTracking
SELECT   TOP (1) @activityGuid AS ActivityGuid, GETDATE() AS TrackedAt, @activityName AS ActivityName, 
                UserActivityAssignments.AssignedUser, @workflowGuid AS WorkflowGuid, @activityDescription AS ActivityDescription, 
                @activityTypeName AS ActivityTypeName, aspnet_Roles.RoleId AS RequiredRole, @status AS Status, 
                @workItemName AS WorkItemName, @workItemType AS WorkItemType, @description AS Description, 
                @isAnonymous AS IsAnonymous, @dateReport AS DateReport, @advice AS Advice, @otherAdvice AS OtherAdvice, 
                @approved AS Approved, @reporterID AS ReporterID
FROM      aspnet_Roles LEFT OUTER JOIN
                UserActivityAssignments ON UserActivityAssignments.ActivityGuid = @activityGuid
WHERE   (aspnet_Roles.RoleName = @requiredRole)
ORDER BY UserActivityAssignments.DateAssigned DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@activityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@activityName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@workflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@activityDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@activityTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@requiredRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@workItemName" Precision="0" ProviderType="NVarChar" Scale="0" Size="512" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@workItemType" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="NVarChar" Scale="0" Size="512" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isAnonymous" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dateReport" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@advice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@otherAdvice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@approved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@reporterID" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CountActivityRecordWithStatus" Modifier="Public" Name="CountActivityRecordWithStatus" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="CountActivityRecordWithStatus">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   COUNT(*) AS Expr1
FROM      UserActivityWorkItemTracking
WHERE   (ActivityGuid = @activityGuid) AND (Status = @status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="activityGuid" ColumnName="ActivityGuid" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@activityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="status" ColumnName="Status" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="SMS.dbo.UserActivityWorkItemTracking" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Get" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetLatestFor" GeneratorSourceName="Get" GetMethodModifier="Public" GetMethodName="GetLatestFor" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetLatestFor" UserSourceName="Get">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   TOP (1) ActivityDescription, ActivityGuid, ActivityName, ActivityTypeName, Approved, AssignedUser, RequiredRole, 
                Status, TrackedAt, WorkItemName, WorkItemType, WorkflowGuid, ReporterID, otherAdvice, Advice, DateReport, 
                IsAnonymous
FROM      UserActivityWorkItemTracking
WHERE   (WorkflowGuid = @workflowGuid)
ORDER BY TrackedAt DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="workflowGuid" ColumnName="WorkflowGuid" DataSourceName="SMS.dbo.UserActivityWorkItemTracking" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@workflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserActivityTrackingRecordTableAdapter" GeneratorDataComponentClassName="UserActivityTrackingRecordTableAdapter" Name="UserActivityTrackingRecord" UserDataComponentName="UserActivityTrackingRecordTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="SMS.dbo.UserActivityTrackingRecord" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   UserActivityTrackingRecord.*
FROM      UserActivityTrackingRecord</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WorkflowGuid" DataSetColumn="WorkflowGuid" />
              <Mapping SourceColumn="TrackedAt" DataSetColumn="TrackedAt" />
              <Mapping SourceColumn="ActivityName" DataSetColumn="ActivityName" />
              <Mapping SourceColumn="ActivityGuid" DataSetColumn="ActivityGuid" />
              <Mapping SourceColumn="ActivityTypeName" DataSetColumn="ActivityTypeName" />
              <Mapping SourceColumn="ActivityDescription" DataSetColumn="ActivityDescription" />
              <Mapping SourceColumn="RequiredRole" DataSetColumn="RequiredRole" />
              <Mapping SourceColumn="AssignedUser" DataSetColumn="AssignedUser" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="WorkItemName" DataSetColumn="WorkItemName" />
              <Mapping SourceColumn="WorkItemType" DataSetColumn="WorkItemType" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="IsAnonymous" DataSetColumn="IsAnonymous" />
              <Mapping SourceColumn="DateReport" DataSetColumn="DateReport" />
              <Mapping SourceColumn="Advice" DataSetColumn="Advice" />
              <Mapping SourceColumn="OtherAdvice" DataSetColumn="OtherAdvice" />
              <Mapping SourceColumn="Approved" DataSetColumn="Approved" />
              <Mapping SourceColumn="ReporterID" DataSetColumn="ReporterID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="SMS.dbo.UserActivityTrackingRecord" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Get" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetTrackingRecordsForWorkflow" GeneratorSourceName="Get" GetMethodModifier="Public" GetMethodName="GetTrackingRecordsForWorkflow" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetTrackingRecordsForWorkflow" UserSourceName="Get">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   *
FROM      UserActivityTrackingRecord
WHERE   (WorkflowGuid = @workflowGuid)
ORDER BY TrackedAt DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="workflowGuid" ColumnName="WorkflowGuid" DataSourceName="SMS.dbo.UserActivityTrackingRecord" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@workflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="WorkflowGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="TrackingDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="TrackingDataSet" msprop:Generator_DataSetName="TrackingDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="UserActivityWorkItemTracking2" msprop:Generator_UserTableName="UserActivityWorkItemTracking2" msprop:Generator_RowDeletedName="UserActivityWorkItemTracking2RowDeleted" msprop:Generator_RowChangedName="UserActivityWorkItemTracking2RowChanged" msprop:Generator_RowClassName="UserActivityWorkItemTracking2Row" msprop:Generator_RowChangingName="UserActivityWorkItemTracking2RowChanging" msprop:Generator_RowEvArgName="UserActivityWorkItemTracking2RowChangeEvent" msprop:Generator_RowEvHandlerName="UserActivityWorkItemTracking2RowChangeEventHandler" msprop:Generator_TableClassName="UserActivityWorkItemTracking2DataTable" msprop:Generator_TableVarName="tableUserActivityWorkItemTracking2" msprop:Generator_RowDeletingName="UserActivityWorkItemTracking2RowDeleting" msprop:Generator_TablePropName="UserActivityWorkItemTracking2">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ActivityGuid" msprop:Generator_UserColumnName="ActivityGuid" msprop:Generator_ColumnPropNameInRow="ActivityGuid" msprop:Generator_ColumnVarNameInTable="columnActivityGuid" msprop:Generator_ColumnPropNameInTable="ActivityGuidColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrackedAt" msprop:Generator_UserColumnName="TrackedAt" msprop:Generator_ColumnPropNameInRow="TrackedAt" msprop:Generator_ColumnVarNameInTable="columnTrackedAt" msprop:Generator_ColumnPropNameInTable="TrackedAtColumn" type="xs:dateTime" />
              <xs:element name="AssignedUser" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="AssignedUser" msprop:Generator_ColumnPropNameInRow="AssignedUser" msprop:Generator_ColumnVarNameInTable="columnAssignedUser" msprop:Generator_ColumnPropNameInTable="AssignedUserColumn" type="xs:string" minOccurs="0" />
              <xs:element name="WorkflowGuid" msprop:Generator_UserColumnName="WorkflowGuid" msprop:Generator_ColumnPropNameInRow="WorkflowGuid" msprop:Generator_ColumnVarNameInTable="columnWorkflowGuid" msprop:Generator_ColumnPropNameInTable="WorkflowGuidColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActivityDescription" msprop:Generator_UserColumnName="ActivityDescription" msprop:Generator_ColumnPropNameInRow="ActivityDescription" msprop:Generator_ColumnVarNameInTable="columnActivityDescription" msprop:Generator_ColumnPropNameInTable="ActivityDescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActivityTypeName" msprop:Generator_UserColumnName="ActivityTypeName" msprop:Generator_ColumnPropNameInRow="ActivityTypeName" msprop:Generator_ColumnVarNameInTable="columnActivityTypeName" msprop:Generator_ColumnPropNameInTable="ActivityTypeNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RequiredRole" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="RequiredRole" msprop:Generator_ColumnPropNameInRow="RequiredRole" msprop:Generator_ColumnVarNameInTable="columnRequiredRole" msprop:Generator_ColumnPropNameInTable="RequiredRoleColumn" type="xs:string" />
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WorkItemName" msprop:Generator_UserColumnName="WorkItemName" msprop:Generator_ColumnPropNameInRow="WorkItemName" msprop:Generator_ColumnVarNameInTable="columnWorkItemName" msprop:Generator_ColumnPropNameInTable="WorkItemNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WorkItemType" msprop:Generator_UserColumnName="WorkItemType" msprop:Generator_ColumnPropNameInRow="WorkItemType" msprop:Generator_ColumnVarNameInTable="columnWorkItemType" msprop:Generator_ColumnPropNameInTable="WorkItemTypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reason" msprop:Generator_UserColumnName="Reason" msprop:Generator_ColumnPropNameInRow="Reason" msprop:Generator_ColumnVarNameInTable="columnReason" msprop:Generator_ColumnPropNameInTable="ReasonColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateRequested" msprop:Generator_UserColumnName="DateRequested" msprop:Generator_ColumnPropNameInRow="DateRequested" msprop:Generator_ColumnVarNameInTable="columnDateRequested" msprop:Generator_ColumnPropNameInTable="DateRequestedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FundingCostCenter" msprop:Generator_UserColumnName="FundingCostCenter" msprop:Generator_ColumnPropNameInRow="FundingCostCenter" msprop:Generator_ColumnVarNameInTable="columnFundingCostCenter" msprop:Generator_ColumnPropNameInTable="FundingCostCenterColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AreaAffected" msprop:Generator_UserColumnName="AreaAffected" msprop:Generator_ColumnPropNameInRow="AreaAffected" msprop:Generator_ColumnVarNameInTable="columnAreaAffected" msprop:Generator_ColumnPropNameInTable="AreaAffectedColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Approved" msprop:Generator_UserColumnName="Approved" msprop:Generator_ColumnPropNameInRow="Approved" msprop:Generator_ColumnVarNameInTable="columnApproved" msprop:Generator_ColumnPropNameInTable="ApprovedColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Result" msprop:Generator_UserColumnName="Result" msprop:Generator_ColumnPropNameInRow="Result" msprop:Generator_ColumnVarNameInTable="columnResult" msprop:Generator_ColumnPropNameInTable="ResultColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActivityName" msprop:Generator_UserColumnName="ActivityName" msprop:Generator_ColumnVarNameInTable="columnActivityName" msprop:Generator_ColumnPropNameInRow="ActivityName" msprop:Generator_ColumnPropNameInTable="ActivityNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WorkflowTracking" msprop:Generator_UserTableName="WorkflowTracking" msprop:Generator_RowDeletedName="WorkflowTrackingRowDeleted" msprop:Generator_RowChangedName="WorkflowTrackingRowChanged" msprop:Generator_RowClassName="WorkflowTrackingRow" msprop:Generator_RowChangingName="WorkflowTrackingRowChanging" msprop:Generator_RowEvArgName="WorkflowTrackingRowChangeEvent" msprop:Generator_RowEvHandlerName="WorkflowTrackingRowChangeEventHandler" msprop:Generator_TableClassName="WorkflowTrackingDataTable" msprop:Generator_TableVarName="tableWorkflowTracking" msprop:Generator_RowDeletingName="WorkflowTrackingRowDeleting" msprop:Generator_TablePropName="WorkflowTracking">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WorkflowGuid" msprop:Generator_UserColumnName="WorkflowGuid" msprop:Generator_ColumnPropNameInRow="WorkflowGuid" msprop:Generator_ColumnVarNameInTable="columnWorkflowGuid" msprop:Generator_ColumnPropNameInTable="WorkflowGuidColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Started" msprop:Generator_UserColumnName="Started" msprop:Generator_ColumnPropNameInRow="Started" msprop:Generator_ColumnVarNameInTable="columnStarted" msprop:Generator_ColumnPropNameInTable="StartedColumn" type="xs:dateTime" />
              <xs:element name="Finished" msprop:Generator_UserColumnName="Finished" msprop:Generator_ColumnPropNameInRow="Finished" msprop:Generator_ColumnVarNameInTable="columnFinished" msprop:Generator_ColumnPropNameInTable="FinishedColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WorkflowInformation" msprop:Generator_UserTableName="WorkflowInformation" msprop:Generator_RowDeletedName="WorkflowInformationRowDeleted" msprop:Generator_RowChangedName="WorkflowInformationRowChanged" msprop:Generator_RowClassName="WorkflowInformationRow" msprop:Generator_RowChangingName="WorkflowInformationRowChanging" msprop:Generator_RowEvArgName="WorkflowInformationRowChangeEvent" msprop:Generator_RowEvHandlerName="WorkflowInformationRowChangeEventHandler" msprop:Generator_TableClassName="WorkflowInformationDataTable" msprop:Generator_TableVarName="tableWorkflowInformation" msprop:Generator_RowDeletingName="WorkflowInformationRowDeleting" msprop:Generator_TablePropName="WorkflowInformation">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WorkflowGuid" msprop:Generator_UserColumnName="WorkflowGuid" msprop:Generator_ColumnVarNameInTable="columnWorkflowGuid" msprop:Generator_ColumnPropNameInRow="WorkflowGuid" msprop:Generator_ColumnPropNameInTable="WorkflowGuidColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Started" msprop:Generator_UserColumnName="Started" msprop:Generator_ColumnVarNameInTable="columnStarted" msprop:Generator_ColumnPropNameInRow="Started" msprop:Generator_ColumnPropNameInTable="StartedColumn" type="xs:dateTime" />
              <xs:element name="WaitingOn" msdata:ReadOnly="true" msprop:Generator_UserColumnName="WaitingOn" msprop:Generator_ColumnVarNameInTable="columnWaitingOn" msprop:Generator_ColumnPropNameInRow="WaitingOn" msprop:Generator_ColumnPropNameInTable="WaitingOnColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Finished" msprop:Generator_UserColumnName="Finished" msprop:Generator_ColumnVarNameInTable="columnFinished" msprop:Generator_ColumnPropNameInRow="Finished" msprop:Generator_ColumnPropNameInTable="FinishedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Name" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UserActivityWorkItemTracking" msprop:Generator_UserTableName="UserActivityWorkItemTracking" msprop:Generator_RowDeletedName="UserActivityWorkItemTrackingRowDeleted" msprop:Generator_RowChangedName="UserActivityWorkItemTrackingRowChanged" msprop:Generator_RowClassName="UserActivityWorkItemTrackingRow" msprop:Generator_RowChangingName="UserActivityWorkItemTrackingRowChanging" msprop:Generator_RowEvArgName="UserActivityWorkItemTrackingRowChangeEvent" msprop:Generator_RowEvHandlerName="UserActivityWorkItemTrackingRowChangeEventHandler" msprop:Generator_TableClassName="UserActivityWorkItemTrackingDataTable" msprop:Generator_TableVarName="tableUserActivityWorkItemTracking" msprop:Generator_RowDeletingName="UserActivityWorkItemTrackingRowDeleting" msprop:Generator_TablePropName="UserActivityWorkItemTracking">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ActivityGuid" msprop:Generator_UserColumnName="ActivityGuid" msprop:Generator_ColumnVarNameInTable="columnActivityGuid" msprop:Generator_ColumnPropNameInRow="ActivityGuid" msprop:Generator_ColumnPropNameInTable="ActivityGuidColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrackedAt" msprop:Generator_UserColumnName="TrackedAt" msprop:Generator_ColumnVarNameInTable="columnTrackedAt" msprop:Generator_ColumnPropNameInRow="TrackedAt" msprop:Generator_ColumnPropNameInTable="TrackedAtColumn" type="xs:dateTime" />
              <xs:element name="ActivityName" msprop:Generator_UserColumnName="ActivityName" msprop:Generator_ColumnVarNameInTable="columnActivityName" msprop:Generator_ColumnPropNameInRow="ActivityName" msprop:Generator_ColumnPropNameInTable="ActivityNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AssignedUser" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="AssignedUser" msprop:Generator_ColumnVarNameInTable="columnAssignedUser" msprop:Generator_ColumnPropNameInRow="AssignedUser" msprop:Generator_ColumnPropNameInTable="AssignedUserColumn" type="xs:string" minOccurs="0" />
              <xs:element name="WorkflowGuid" msprop:Generator_UserColumnName="WorkflowGuid" msprop:Generator_ColumnVarNameInTable="columnWorkflowGuid" msprop:Generator_ColumnPropNameInRow="WorkflowGuid" msprop:Generator_ColumnPropNameInTable="WorkflowGuidColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActivityDescription" msprop:Generator_UserColumnName="ActivityDescription" msprop:Generator_ColumnVarNameInTable="columnActivityDescription" msprop:Generator_ColumnPropNameInRow="ActivityDescription" msprop:Generator_ColumnPropNameInTable="ActivityDescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActivityTypeName" msprop:Generator_UserColumnName="ActivityTypeName" msprop:Generator_ColumnVarNameInTable="columnActivityTypeName" msprop:Generator_ColumnPropNameInRow="ActivityTypeName" msprop:Generator_ColumnPropNameInTable="ActivityTypeNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RequiredRole" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="RequiredRole" msprop:Generator_ColumnVarNameInTable="columnRequiredRole" msprop:Generator_ColumnPropNameInRow="RequiredRole" msprop:Generator_ColumnPropNameInTable="RequiredRoleColumn" type="xs:string" />
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WorkItemName" msprop:Generator_UserColumnName="WorkItemName" msprop:Generator_ColumnVarNameInTable="columnWorkItemName" msprop:Generator_ColumnPropNameInRow="WorkItemName" msprop:Generator_ColumnPropNameInTable="WorkItemNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WorkItemType" msprop:Generator_UserColumnName="WorkItemType" msprop:Generator_ColumnVarNameInTable="columnWorkItemType" msprop:Generator_ColumnPropNameInRow="WorkItemType" msprop:Generator_ColumnPropNameInTable="WorkItemTypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsAnonymous" msprop:Generator_UserColumnName="IsAnonymous" msprop:Generator_ColumnVarNameInTable="columnIsAnonymous" msprop:Generator_ColumnPropNameInRow="IsAnonymous" msprop:Generator_ColumnPropNameInTable="IsAnonymousColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="DateReport" msprop:Generator_UserColumnName="DateReport" msprop:Generator_ColumnVarNameInTable="columnDateReport" msprop:Generator_ColumnPropNameInRow="DateReport" msprop:Generator_ColumnPropNameInTable="DateReportColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Advice" msprop:Generator_UserColumnName="Advice" msprop:Generator_ColumnVarNameInTable="columnAdvice" msprop:Generator_ColumnPropNameInRow="Advice" msprop:Generator_ColumnPropNameInTable="AdviceColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="otherAdvice" msprop:Generator_UserColumnName="otherAdvice" msprop:Generator_ColumnVarNameInTable="columnotherAdvice" msprop:Generator_ColumnPropNameInRow="otherAdvice" msprop:Generator_ColumnPropNameInTable="otherAdviceColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Approved" msprop:Generator_UserColumnName="Approved" msprop:Generator_ColumnVarNameInTable="columnApproved" msprop:Generator_ColumnPropNameInRow="Approved" msprop:Generator_ColumnPropNameInTable="ApprovedColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ReporterID" msprop:Generator_UserColumnName="ReporterID" msprop:Generator_ColumnVarNameInTable="columnReporterID" msprop:Generator_ColumnPropNameInRow="ReporterID" msprop:Generator_ColumnPropNameInTable="ReporterIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UserActivityTrackingRecord" msprop:Generator_UserTableName="UserActivityTrackingRecord" msprop:Generator_RowDeletedName="UserActivityTrackingRecordRowDeleted" msprop:Generator_TableClassName="UserActivityTrackingRecordDataTable" msprop:Generator_RowChangedName="UserActivityTrackingRecordRowChanged" msprop:Generator_RowClassName="UserActivityTrackingRecordRow" msprop:Generator_RowChangingName="UserActivityTrackingRecordRowChanging" msprop:Generator_RowEvArgName="UserActivityTrackingRecordRowChangeEvent" msprop:Generator_RowEvHandlerName="UserActivityTrackingRecordRowChangeEventHandler" msprop:Generator_TablePropName="UserActivityTrackingRecord" msprop:Generator_TableVarName="tableUserActivityTrackingRecord" msprop:Generator_RowDeletingName="UserActivityTrackingRecordRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WorkflowGuid" msprop:Generator_UserColumnName="WorkflowGuid" msprop:Generator_ColumnPropNameInRow="WorkflowGuid" msprop:Generator_ColumnVarNameInTable="columnWorkflowGuid" msprop:Generator_ColumnPropNameInTable="WorkflowGuidColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrackedAt" msprop:Generator_UserColumnName="TrackedAt" msprop:Generator_ColumnPropNameInRow="TrackedAt" msprop:Generator_ColumnVarNameInTable="columnTrackedAt" msprop:Generator_ColumnPropNameInTable="TrackedAtColumn" type="xs:dateTime" />
              <xs:element name="ActivityName" msprop:Generator_UserColumnName="ActivityName" msprop:Generator_ColumnPropNameInRow="ActivityName" msprop:Generator_ColumnVarNameInTable="columnActivityName" msprop:Generator_ColumnPropNameInTable="ActivityNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActivityGuid" msprop:Generator_UserColumnName="ActivityGuid" msprop:Generator_ColumnPropNameInRow="ActivityGuid" msprop:Generator_ColumnVarNameInTable="columnActivityGuid" msprop:Generator_ColumnPropNameInTable="ActivityGuidColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActivityTypeName" msprop:Generator_UserColumnName="ActivityTypeName" msprop:Generator_ColumnPropNameInRow="ActivityTypeName" msprop:Generator_ColumnVarNameInTable="columnActivityTypeName" msprop:Generator_ColumnPropNameInTable="ActivityTypeNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActivityDescription" msprop:Generator_UserColumnName="ActivityDescription" msprop:Generator_ColumnPropNameInRow="ActivityDescription" msprop:Generator_ColumnVarNameInTable="columnActivityDescription" msprop:Generator_ColumnPropNameInTable="ActivityDescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RequiredRole" msprop:Generator_UserColumnName="RequiredRole" msprop:Generator_ColumnPropNameInRow="RequiredRole" msprop:Generator_ColumnVarNameInTable="columnRequiredRole" msprop:Generator_ColumnPropNameInTable="RequiredRoleColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AssignedUser" msprop:Generator_UserColumnName="AssignedUser" msprop:Generator_ColumnPropNameInRow="AssignedUser" msprop:Generator_ColumnVarNameInTable="columnAssignedUser" msprop:Generator_ColumnPropNameInTable="AssignedUserColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WorkItemName" msprop:Generator_UserColumnName="WorkItemName" msprop:Generator_ColumnPropNameInRow="WorkItemName" msprop:Generator_ColumnVarNameInTable="columnWorkItemName" msprop:Generator_ColumnPropNameInTable="WorkItemNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WorkItemType" msprop:Generator_UserColumnName="WorkItemType" msprop:Generator_ColumnPropNameInRow="WorkItemType" msprop:Generator_ColumnVarNameInTable="columnWorkItemType" msprop:Generator_ColumnPropNameInTable="WorkItemTypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsAnonymous" msprop:Generator_UserColumnName="IsAnonymous" msprop:Generator_ColumnPropNameInRow="IsAnonymous" msprop:Generator_ColumnVarNameInTable="columnIsAnonymous" msprop:Generator_ColumnPropNameInTable="IsAnonymousColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="DateReport" msprop:Generator_UserColumnName="DateReport" msprop:Generator_ColumnPropNameInRow="DateReport" msprop:Generator_ColumnVarNameInTable="columnDateReport" msprop:Generator_ColumnPropNameInTable="DateReportColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Advice" msprop:Generator_UserColumnName="Advice" msprop:Generator_ColumnPropNameInRow="Advice" msprop:Generator_ColumnVarNameInTable="columnAdvice" msprop:Generator_ColumnPropNameInTable="AdviceColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OtherAdvice" msprop:Generator_UserColumnName="OtherAdvice" msprop:Generator_ColumnPropNameInRow="OtherAdvice" msprop:Generator_ColumnVarNameInTable="columnOtherAdvice" msprop:Generator_ColumnPropNameInTable="OtherAdviceColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Approved" msprop:Generator_UserColumnName="Approved" msprop:Generator_ColumnPropNameInRow="Approved" msprop:Generator_ColumnVarNameInTable="columnApproved" msprop:Generator_ColumnPropNameInTable="ApprovedColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ReporterID" msprop:Generator_UserColumnName="ReporterID" msprop:Generator_ColumnPropNameInRow="ReporterID" msprop:Generator_ColumnVarNameInTable="columnReporterID" msprop:Generator_ColumnPropNameInTable="ReporterIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserActivityWorkItemTracking2" />
      <xs:field xpath="mstns:ActivityGuid" />
      <xs:field xpath="mstns:TrackedAt" />
    </xs:unique>
    <xs:unique name="WorkflowTracking_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WorkflowTracking" />
      <xs:field xpath="mstns:WorkflowGuid" />
    </xs:unique>
    <xs:unique name="WorkflowInformation_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WorkflowInformation" />
      <xs:field xpath="mstns:WorkflowGuid" />
    </xs:unique>
    <xs:unique name="UserActivityWorkItemTracking_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserActivityWorkItemTracking" />
      <xs:field xpath="mstns:ActivityGuid" />
      <xs:field xpath="mstns:TrackedAt" />
    </xs:unique>
    <xs:unique name="UserActivityTrackingRecord_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserActivityTrackingRecord" />
      <xs:field xpath="mstns:TrackedAt" />
      <xs:field xpath="mstns:ActivityGuid" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_UserActivityWorkItemTracking_WorkflowTracking" msdata:parent="WorkflowTracking" msdata:child="UserActivityWorkItemTracking2" msdata:parentkey="WorkflowGuid" msdata:childkey="WorkflowGuid" msprop:Generator_UserRelationName="FK_UserActivityWorkItemTracking_WorkflowTracking" msprop:Generator_RelationVarName="relationFK_UserActivityWorkItemTracking_WorkflowTracking" msprop:Generator_UserChildTable="UserActivityWorkItemTracking2" msprop:Generator_UserParentTable="WorkflowTracking" msprop:Generator_ParentPropName="WorkflowTrackingRow" msprop:Generator_ChildPropName="GetUserActivityWorkItemTrackingRows" />
      <msdata:Relationship name="FK_UserActivityWorkItemTracking_WorkflowTracking1" msdata:parent="WorkflowTracking" msdata:child="UserActivityWorkItemTracking" msdata:parentkey="WorkflowGuid" msdata:childkey="WorkflowGuid" msprop:Generator_UserRelationName="FK_UserActivityWorkItemTracking_WorkflowTracking1" msprop:Generator_RelationVarName="relationFK_UserActivityWorkItemTracking_WorkflowTracking1" msprop:Generator_UserChildTable="UserActivityWorkItemTracking" msprop:Generator_UserParentTable="WorkflowTracking" msprop:Generator_ParentPropName="WorkflowTrackingRow" msprop:Generator_ChildPropName="_GetUserActivityWorkItemTrackingRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>